package com.ssish.saas.eccs.mapper;

import com.ssish.saas.eccs.model.PayorProviderMapping;
import com.ssish.saas.eccs.model.PayorProviderMappingExample;
import java.util.List;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;

public interface PayorProviderMappingMapper {
    int countByExample(PayorProviderMappingExample example);

    int deleteByExample(PayorProviderMappingExample example);

    @Insert({
        "insert into PAYOR_PROVIDER_MAPPING (PAYOR_CODE, PAYOR_PROVIDER_CODE, ",
        "PAYOR_PROVIDER_NAME, PROVIDER_CODE, ",
        "PROVIDER_NAME, VAR1, ",
        "VAR2, VAR3, PROIVDER_TEL, ",
        "PROIVDER_ADDRESS, PROIVDER_MANAGENCY)",
        "values (#{payorCode,jdbcType=CHAR}, #{payorProviderCode,jdbcType=VARCHAR}, ",
        "#{payorProviderName,jdbcType=VARCHAR}, #{providerCode,jdbcType=VARCHAR}, ",
        "#{providerName,jdbcType=VARCHAR}, #{var1,jdbcType=VARCHAR}, ",
        "#{var2,jdbcType=VARCHAR}, #{var3,jdbcType=VARCHAR}, #{proivderTel,jdbcType=VARCHAR}, ",
        "#{proivderAddress,jdbcType=VARCHAR}, #{proivderManagency,jdbcType=VARCHAR})"
    })
    int insert(PayorProviderMapping record);

    int insertSelective(PayorProviderMapping record);

    List<PayorProviderMapping> selectByExample(PayorProviderMappingExample example);

    int updateByExampleSelective(@Param("record") PayorProviderMapping record, @Param("example") PayorProviderMappingExample example);

    int updateByExample(@Param("record") PayorProviderMapping record, @Param("example") PayorProviderMappingExample example);
}